Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

Adding extended 4GL support

The DataServer provides support for arrays and the RECID/ROWID function when certain objects exist in a data source. You can modify your data source to support these extended features. You can also add support for these features when you create new tables.

The DataServer maintains the columns that you add to your data source tables to support these extended features. If non-OpenEdge applications are updating those data source tables, these applications must be aware of the additional columns and update them appropriately. You can use triggers, if your data source supports them, to make sure that the columns are updated correctly.

The following sections describe how to modify an existing data source so that it supports arrays, and OpenEdge record identifiers. See the "ROWID function" section for alternate ways to support this function.